APPS.QA_SS_SHIP dependencies on POS_PO_QA_SHIPMENTS_V

Line 72: -- PO calls this function in their view pos_po_qa_shipments_v .

68: CLOSE org_cur;
69: END IF;
70:
71: -- anagarwa Tue Nov 13 17:26:18 PST 2001
72: -- PO calls this function in their view pos_po_qa_shipments_v .
73: -- The last parameter they pass us is item_category. But the
74: -- supplied value is incorrect as they do not check for the profile
75: -- FND_PROFILE.VALUE('QA_CATEGORY_SET').
76: -- To circumvent this dependency and to avoid changes in POS code,

Line 175: -- Changed view ICX_POS_QA_SHIPMENTS_V to POS_PO_QA_SHIPMENTS_V

171: -- only for the purpose of finding out po_agent_id
172: -- fixing base_po_num below for Bug 1241396
173:
174: -- R12 Project MOAC 4637896
175: -- Changed view ICX_POS_QA_SHIPMENTS_V to POS_PO_QA_SHIPMENTS_V
176: CURSOR def_ship_cur IS
177: SELECT BASE_PO_NUM, LINE_NUMBER,
178: PO_RELEASE_ID, SHIPMENT_NUMBER,
179: Ship_To_Location_Code, Supplier_Item_Number,

Line 186: FROM pos_po_qa_shipments_v

182: ship_to_organization_name,
183: Item_Number, Item_Revision,
184: Category, PO_HEADER_ID, Item_ID, -- already selected po_release_id above
185: Po_Line_Id, Po_Shipment_Id, Ship_To_Organization_Id
186: FROM pos_po_qa_shipments_v
187: Where Po_Shipment_Id = to_number(PK1);
188:
189: CURSOR rel_num_cur (x_rel_id IN NUMBER) IS
190: SELECT RELEASE_NUM

Line 300: -- Changed view ICX_POS_QA_SHIPMENTS_V to POS_PO_QA_SHIPMENTS_V

296:
297: -- fixing base_po_num for bug 1241396
298:
299: -- R12 Project MOAC 4637896
300: -- Changed view ICX_POS_QA_SHIPMENTS_V to POS_PO_QA_SHIPMENTS_V
301: CURSOR ship_cur IS
302: SELECT BASE_PO_NUM, LINE_NUMBER,
303: PO_RELEASE_ID, SHIPMENT_NUMBER,
304: Ship_To_Location_Code, Supplier_Item_Number,

Line 310: FROM pos_po_qa_shipments_v

306: supplier_name, supplier_site_code,
307: ship_to_organization_name,
308: Item_Number, Item_Revision,
309: Category, Ship_To_Organization_ID
310: FROM pos_po_qa_shipments_v
311: Where Po_Shipment_Id = to_number(PK1);
312:
313: CURSOR rel_num_cur (x_rel_id IN NUMBER) IS
314: SELECT RELEASE_NUM