APPS.QA_SS_OSP dependencies on WIP_ICX_OSP_WORKBENCH_V

Line 154: FROM WIP_ICX_OSP_WORKBENCH_V

150: Wip_Entity_Type, Wip_Repetitive_Schedule_Id,
151: Po_Line_Id, Line_Location_Id,
152: Po_Distribution_Id, Wip_Entity_Id,
153: Wip_Line_Id, Organization_Id
154: FROM WIP_ICX_OSP_WORKBENCH_V
155: Where Po_Distribution_Id = to_number(PK1);
156:
157: CURSOR buyer1_cur(p_h_id IN NUMBER) IS
158: SELECT AGENT_ID

Line 186: -- View Name is WIP_ICX_OSP_WORKBENCH_V

182: -- the lov code should figure this
183: -- if there are problems then we can modify the architecture
184: -- to maybe pickout the ids here. test and see
185:
186: -- View Name is WIP_ICX_OSP_WORKBENCH_V
187: -- Use base_po_num column from this view
188: -- TYPO "Vender"_Item_Number in seed data
189:
190: OPEN def_osp_cur;

Line 263: FROM WIP_ICX_OSP_WORKBENCH_V

259: Wip_Operation_Seq_Num, Assembly_Primary_UOM,
260: Wip_Line_code, Assembly_Quantity_Ordered,
261: Assembly_Item_Revision, Po_Release_Number,
262: Organization_Id
263: FROM WIP_ICX_OSP_WORKBENCH_V
264: Where Po_Distribution_Id = to_number(PK1);
265: BEGIN
266:
267: -- View Name is WIP_ICX_OSP_WORKBENCH_V

Line 267: -- View Name is WIP_ICX_OSP_WORKBENCH_V

263: FROM WIP_ICX_OSP_WORKBENCH_V
264: Where Po_Distribution_Id = to_number(PK1);
265: BEGIN
266:
267: -- View Name is WIP_ICX_OSP_WORKBENCH_V
268: -- Use base_po_num column from this view
269: -- Typo "Vender"_Item_Number in seed data
270: if (icx_sec.validatesession) then
271: OPEN osp_cur;