| Query to find attachement for wip operation sequence number [message #514087] |
Fri, 01 July 2011 05:53  |
 |
goparaju
Messages: 54
Registered: June 2011
|
Member |
|
|
Hi Experts,
I am working on EBS 11.5.10. I want table link to find attachments for particular operation sequence number.
Navigation:
WORK IN PROCESS --> DISCRETE JOBS --> OPERATIONS --> ATTACHMENTS(IN MENU YOU CAN FIND).
In operations screen, for each operation sequence number, you can have attachement.In attachement, i want to pick the remarks column.
Table: OPERATIONS -- WIP_OPERATIONS
ATTACHEMENTS - FND_ATTACHED_DOCS_FORM_VL
REMARKS - fnd_documents_short_text
Link between FND_ATTACHED_DOCS_FORM_VL and fnd_documents_short_text is media_id. But i am not able to find the link between wip_operations and fnd_attached_docs_form_vl.
Could anybody help me how to get attachement data for a particular operation sequence number.
Note: I am attaching the screen shot of the what i am looking for.
Thanks in advance.
|
|
|
|
| Re: Query to find attachement for wip operation sequence number [message #514232 is a reply to message #514087] |
Sat, 02 July 2011 13:56  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
I'm not familiar with WIP.
I just checked the data in FND_ATTACHED_DOCS_FORM_VL.
As attachments is generic for all components, it does look like entity_name and function_name distinguishes the component.
These attachments are related to WIP, Discrete Jobs and Operations, entity_name may be WIP_DISCRETE_OPERATIONS.
And the PK values in the view FND_ATTACHED_DOCS_FORM_VL are the PK values in main table.
fnd_attached_docs_form_vl.entity_name = 'WIP_DISCRETE_OPERATIONS'
AND pk1_value = wip_operations.wip_entity_id
AND pk2_value = wip_operations.operation_seq_num
AND pk3_value = wip_operations.organization_id
Even I'm not clear why repetitive_schedule_id is not present in the view.
U1 key contain repetitive_schedule_id, but primary key doesn't contain organization_id.
If they consider U1 key, repetitive_schedule_id should be present as pk4_value.
If they consider PK, repetitive_schedule_id should be pk3_value.
Also fnd_attached_docs_form_vl.security_id = wip_operations.organization_id
Anyway simple way to check what exactly is being passed to attachments form is:
Once you open the attachment window, check the system.last_query.
Go to Help -> Diagnostics and enter
Block -> SYSTEM
Field -> LAST_QUERY
By
Vamsi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
