eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_DROP_SHIP_GRP dependencies on OE_DROP_SHIP_SOURCES

Line 33: From OE_DROP_SHIP_SOURCES

29: Return Boolean
30: IS
31: Cursor L_Drop_Ship_Source_ID_Csr Is
32: Select Count(*)
33: From OE_DROP_SHIP_SOURCES
34: Where Drop_Ship_Source_ID = P_Drop_Ship_Source_ID ;
35: --
36: L_Drop_Ship_Source_Count Number(4);
37:

Line 58: PROCEDURE Insert_OE_Drop_Ship_Sources

54: PROCEDURE : Insert_OE_Drop_Ship_Source
55: DESCRIPTION:
56: -----------------------------------------------------------------*/
57:
58: PROCEDURE Insert_OE_Drop_Ship_Sources
59: (P_Drop_Ship_Source_ID In Number,
60: P_Header_ID In Number,
61: P_Line_ID In Number,
62: P_Org_ID In Number,

Line 75: Insert Into OE_Drop_Ship_Sources

71: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
72: --
73: BEGIN
74:
75: Insert Into OE_Drop_Ship_Sources
76: (
77: Drop_Ship_Source_ID,
78: Header_ID,
79: Line_ID,

Line 112: End Insert_OE_Drop_Ship_Sources;

108: Trunc(Sysdate),
109: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
110: );
111:
112: End Insert_OE_Drop_Ship_Sources;
113:
114: /*-----------------------------------------------------------------
115: PROCEDURE : Update_Req_Info
116: DESCRIPTION: Update_Req_Info is an OE procedure that is called by

Line 151: FROM OE_Drop_Ship_Sources

147: Requisition_Header_ID,
148: Requisition_Line_ID,
149: PO_Header_ID,
150: PO_Line_ID
151: FROM OE_Drop_Ship_Sources
152: WHERE Drop_Ship_source_ID = P_Interface_Source_Line_ID
153: FOR UPDATE OF Requisition_Header_ID NOWAIT; -- bug 4503620
154:
155: --

Line 206: UPDATE OE_Drop_Ship_Sources

202: IF L_OE_Drop_Ship_Source_Csr%Found THEN
203: IF G_Requisition_Header_ID Is Null THEN
204: -- Requisition being updated for the first time
205:
206: UPDATE OE_Drop_Ship_Sources
207: SET Requisition_Header_ID = P_Requisition_Header_ID,
208: Requisition_LIne_ID = P_Requisition_Line_ID,
209: Last_Update_Date = Trunc(Sysdate),
210: Last_Updated_By = Nvl(To_Number(FND_PROFILE.VALUE

Line 216: Insert_OE_Drop_Ship_Sources

212: WHERE Current of L_OE_Drop_Ship_Source_Csr;
213:
214: ELSE
215: -- Another requisition for same order line.
216: Insert_OE_Drop_Ship_Sources
217: (P_Drop_Ship_Source_ID => G_Drop_Ship_Source_ID,
218: P_Header_ID => G_Header_ID,
219: P_Line_ID => G_Line_ID,
220: P_Org_ID => G_Org_ID,

Line 394: FROM OE_Drop_Ship_Sources

390: Requisition_Header_ID,
391: Requisition_Line_ID,
392: PO_Header_ID,
393: PO_Line_ID
394: FROM OE_Drop_Ship_Sources
395: WHERE Requisition_Line_ID = P_Req_Line_ID
396: AND Requisition_Header_ID = P_Req_Header_ID
397: FOR Update of PO_Header_ID NOWAIT; -- bug 4503620
398:

Line 429: Update OE_Drop_Ship_Sources

425: IF G_Requisition_Header_ID IS NOT NULL
426: And G_PO_Header_ID IS NULL THEN
427: -- PO being updated for the first time
428:
429: Update OE_Drop_Ship_Sources
430: SET PO_Header_ID = P_PO_Header_ID,
431: PO_Line_ID = P_PO_Line_ID,
432: Line_Location_ID = P_Line_Location_ID,
433: PO_Release_ID = Nvl(P_PO_Release_Id,PO_Release_ID),

Line 438: Insert_OE_Drop_Ship_Sources

434: Last_Update_Date = Trunc(Sysdate),
435: Last_Updated_By = Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
436: WHERE Current of L_OE_Drop_Ship_Source_Csr;
437: ELSE -- Another PO for same order line.
438: Insert_OE_Drop_Ship_Sources
439: (P_Drop_Ship_Source_ID => G_Drop_Ship_Source_ID,
440: P_Header_ID => G_Header_ID,
441: P_Line_ID => G_Line_ID,
442: P_Org_ID => G_Org_ID,

Line 490: FROM OE_Drop_Ship_Sources

486:
487: L_Line_id Number;
488: CURSOR L_Drop_Ship_Csr IS
489: SELECT Line_Id
490: FROM OE_Drop_Ship_Sources
491: WHERE Requisition_Line_ID = P_Req_Line_ID;
492:
493: --
494: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 522: FROM OE_Drop_Ship_Sources

518: IS
519: L_Line_Id Number;
520: Cursor L_Drop_Ship_Csr Is
521: SELECT Line_Id
522: FROM OE_Drop_Ship_Sources
523: WHERE Line_Location_Id = P_PO_Line_Location_ID;
524: --
525: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
526: --

Line 594: UPDATE oe_drop_ship_sources

590: );
591:
592: IF p_new_req_hdr_id IS NOT NULL THEN
593:
594: UPDATE oe_drop_ship_sources
595: SET requisition_header_id = p_new_req_hdr_id,
596: requisition_line_id = p_new_req_line_id,
597: po_header_id = NULL,
598: po_line_id = NULL,

Line 670: oe_drop_ship_sources od,

666:
667: SELECT ol.line_id
668: INTO l_line_id
669: FROM oe_order_lines_all ol,
670: oe_drop_ship_sources od,
671: rcv_transactions rt
672: WHERE ol.line_id = od.line_id
673: AND ol.source_type_code = 'EXTERNAL'
674: AND od.po_header_id = rt.po_header_id

Line 750: FROM oe_drop_ship_sources ds,

746: oel.org_id
747: INTO x_line_id,
748: x_header_id,
749: x_org_id
750: FROM oe_drop_ship_sources ds,
751: oe_order_lines_all oel
752: WHERE line_location_id = p_po_line_location_id
753: AND oel.line_id = ds.line_id
754: AND oel.header_id = ds.header_id

Line 785: FROM oe_drop_ship_sources ds,

781: oel.org_id
782: INTO x_line_id,
783: x_header_id,
784: x_org_id
785: FROM oe_drop_ship_sources ds,
786: oe_order_lines_all oel
787: WHERE line_location_id = p_po_line_location_id
788: AND oel.line_id = ds.line_id
789: AND oel.header_id = ds.header_id;

Line 808: FROM oe_drop_ship_sources ds,

804: SELECT oel.header_id,
805: oel.org_id
806: INTO x_header_id,
807: x_org_id
808: FROM oe_drop_ship_sources ds,
809: oe_order_lines_all oel
810: WHERE line_location_id = p_po_line_location_id
811: AND oel.line_id = ds.line_id
812: AND oel.header_id = ds.header_id

Line 834: oe_drop_ship_sources OD,

830:
831: SELECT MAX(OL.line_id)
832: INTO x_line_id
833: FROM oe_order_lines_all OL,
834: oe_drop_ship_sources OD,
835: rcv_transactions RT
836: WHERE OL.line_id = OD.line_id
837: AND OL.source_type_code = 'EXTERNAL'
838: AND OD.po_header_id = RT.po_header_id

Line 851: FROM oe_drop_ship_sources ds,

847: END IF; -- if p_mode
848:
849: SELECT count(*)
850: INTO x_num_lines
851: FROM oe_drop_ship_sources ds,
852: oe_order_lines_all oel
853: WHERE line_location_id = p_po_line_location_id
854: AND oel.line_id = ds.line_id
855: AND oel.header_id = ds.header_id;

Line 1478: oe_drop_ship_sources table.

1474: Description :
1475: This procedure will be used by PO at the time of
1476: PO purge. OM will validate the order line status
1477: and then null out the PO links from the
1478: oe_drop_ship_sources table.
1479: -------------------------------------------------------*/
1480: Procedure Purge_Drop_Ship_PO_Links
1481: ( p_api_version IN NUMBER
1482: ,p_init_msg_list IN VARCHAR2

Line 1494: FROM oe_drop_ship_sources

1490: IS
1491:
1492: CURSOR c_dropship(cp_entity_id NUMBER) IS
1493: SELECT line_id
1494: FROM oe_drop_ship_sources
1495: WHERE (p_entity = 'PO_REQUISITION_HEADERS' AND
1496: requisition_header_id = cp_entity_id) OR
1497: (p_entity = 'PO_HEADERS' AND
1498: po_header_id = cp_entity_id)

Line 1532: FROM oe_drop_ship_sources

1528: END IF;
1529: CLOSE c_dropship;
1530:
1531: DELETE
1532: FROM oe_drop_ship_sources
1533: WHERE (p_entity = 'PO_REQUISITION_HEADERS' AND
1534: requisition_header_id = p_entity_id_tbl(I)) OR
1535: (p_entity = 'PO_HEADERS' AND
1536: po_header_id = p_entity_id_tbl(I));

Line 1623: FROM oe_drop_ship_sources ds,

1619: IF p_entity = 'PO_REQUSITION_HEADERS'
1620: THEN
1621: SELECT count(*)
1622: INTO l_count
1623: FROM oe_drop_ship_sources ds,
1624: oe_order_lines_all l
1625: WHERE requisition_header_id = p_entity_id_tbl(I)
1626: AND l.line_id = ds.line_id
1627: AND l.header_id = ds.header_id

Line 1633: FROM oe_drop_ship_sources ds,

1629: AND l.shipped_quantity is NULL;
1630: ELSE
1631: SELECT count(*)
1632: INTO l_count
1633: FROM oe_drop_ship_sources ds,
1634: oe_order_lines_all l
1635: WHERE po_header_id = p_entity_id_tbl(I)
1636: AND l.line_id = ds.line_id
1637: AND l.header_id = ds.header_id