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.

[Home] [Help]

APPS.ASO_SHIPMENT_PVT dependencies on ASO_SHIPMENTS

Line 82: -- Invoke table handler(ASO_SHIPMENTS_PKG.Delete_Row)

78: FOR freight_rec IN c_freight_charges LOOP
79: ASO_FREIGHT_CHARGES_PKG.Delete_Row(
80: p_FREIGHT_CHARGE_ID => freight_rec.FREIGHT_CHARGE_ID);
81: END LOOP;
82: -- Invoke table handler(ASO_SHIPMENTS_PKG.Delete_Row)
83: ASO_SHIPMENTS_PKG.Delete_Row(
84: p_SHIPMENT_ID => p_shipment_rec.shipment_id);
85:
86:

Line 83: ASO_SHIPMENTS_PKG.Delete_Row(

79: ASO_FREIGHT_CHARGES_PKG.Delete_Row(
80: p_FREIGHT_CHARGE_ID => freight_rec.FREIGHT_CHARGE_ID);
81: END LOOP;
82: -- Invoke table handler(ASO_SHIPMENTS_PKG.Delete_Row)
83: ASO_SHIPMENTS_PKG.Delete_Row(
84: p_SHIPMENT_ID => p_shipment_rec.shipment_id);
85:
86:
87:

Line 473: SELECT ship_to_party_site_id, SHIP_TO_CUST_ACCOUNT_ID FROM ASO_SHIPMENTS

469: p_qte_line_id NUMBER,
470: p_shipment_id NUMBER) RETURN NUMBER
471: IS
472: CURSOR c_ship_site1 IS
473: SELECT ship_to_party_site_id, SHIP_TO_CUST_ACCOUNT_ID FROM ASO_SHIPMENTS
474: WHERE shipment_id = p_shipment_id AND quote_line_id =
475: p_qte_line_id AND quote_header_id = p_qte_header_id;
476:
477: -- performance fix for bug 5596369

Line 480: FROM ASO_SHIPMENTS

476:
477: -- performance fix for bug 5596369
478: CURSOR c_ship_site2 IS
479: SELECT ship_to_party_site_id , SHIP_TO_CUST_ACCOUNT_ID
480: FROM ASO_SHIPMENTS
481: WHERE quote_header_id = p_qte_header_id
482: and shipment_id =p_shipment_id
483: AND quote_line_id IS NULL;
484:

Line 494: SELECT SHIP_TO_CUST_ACCOUNT_ID FROM ASO_SHIPMENTS

490: SELECT cust_account_id FROM ASO_QUOTE_HEADERS_ALL
491: WHERE quote_header_id = p_qte_header_id;
492:
493: CURSOR c_ship_cust_id IS
494: SELECT SHIP_TO_CUST_ACCOUNT_ID FROM ASO_SHIPMENTS
495: WHERE quote_header_id = p_qte_header_id and quote_line_id =p_qte_line_id and shipment_id =p_shipment_id;
496:
497:
498: -- bug 5596369

Line 501: FROM ASO_SHIPMENTS

497:
498: -- bug 5596369
499: CURSOR c_ship_cust_id1 IS
500: SELECT SHIP_TO_CUST_ACCOUNT_ID
501: FROM ASO_SHIPMENTS
502: WHERE quote_header_id = p_qte_header_id
503: and shipment_id =p_shipment_id
504: and quote_line_id IS NULL;
505:

Line 530: from aso_shipments

526: where quote_line_id = p_qte_line_id;
527:
528: cursor c_shipment_id (p_line_id NUMBER) is
529: select shipment_id
530: from aso_shipments
531: where quote_line_id = p_line_id
532: and quote_header_id = p_qte_header_id;
533:
534: l_cust_id NUMBER;

Line 791: SELECT ship_to_party_site_id FROM ASO_SHIPMENTS

787: p_qte_line_id NUMBER,
788: p_shipment_id NUMBER) RETURN NUMBER
789: IS
790: CURSOR c_ship_site1 IS
791: SELECT ship_to_party_site_id FROM ASO_SHIPMENTS
792: WHERE shipment_id = p_shipment_id
793: AND quote_line_id = p_qte_line_id
794: AND quote_header_id = p_qte_header_id;
795:

Line 797: SELECT ship_to_party_site_id FROM ASO_SHIPMENTS

793: AND quote_line_id = p_qte_line_id
794: AND quote_header_id = p_qte_header_id;
795:
796: CURSOR c_ship_site2 IS
797: SELECT ship_to_party_site_id FROM ASO_SHIPMENTS
798: WHERE quote_line_id IS NULL AND quote_header_id = p_qte_header_id;
799:
800: l_ship_site_id NUMBER;
801:

Line 818: from aso_shipments

814: where quote_line_id = p_qte_line_id;
815:
816: cursor c_shipment_id (p_line_id NUMBER) is
817: select shipment_id
818: from aso_shipments
819: where quote_line_id = p_line_id
820: and quote_header_id = p_qte_header_id;
821:
822: l_model_quote_line_id NUMBER;

Line 1083: SELECT ship_from_org_id FROM ASO_shipments

1079:
1080: IS
1081:
1082: CURSOR c_line_shipment IS
1083: SELECT ship_from_org_id FROM ASO_shipments
1084: WHERE quote_line_id = p_qte_line_id
1085: AND quote_header_id = p_qte_header_id;
1086:
1087:

Line 1089: SELECT ship_from_org_id FROM ASO_shipments

1085: AND quote_header_id = p_qte_header_id;
1086:
1087:
1088: CURSOR c_header_shipment IS
1089: SELECT ship_from_org_id FROM ASO_shipments
1090: WHERE quote_header_id = p_qte_header_id
1091: AND quote_line_id IS NULL;
1092:
1093: l_ship_from_org_id NUMBER;

Line 1134: SELECT ship_method_code FROM ASO_shipments

1130:
1131: IS
1132:
1133: CURSOR c_line_shipment IS
1134: SELECT ship_method_code FROM ASO_shipments
1135: WHERE quote_line_id = p_qte_line_id
1136: AND quote_header_id = p_qte_header_id;
1137:
1138:

Line 1140: SELECT ship_method_code FROM ASO_shipments

1136: AND quote_header_id = p_qte_header_id;
1137:
1138:
1139: CURSOR c_header_shipment IS
1140: SELECT ship_method_code FROM ASO_shipments
1141: WHERE quote_header_id = p_qte_header_id
1142: AND quote_line_id IS NULL;
1143:
1144: l_ship_method_code varchar2(30) := null;

Line 1204: SELECT demand_class_code FROM ASO_shipments

1200:
1201: IS
1202:
1203: CURSOR c_line_shipment IS
1204: SELECT demand_class_code FROM ASO_shipments
1205: WHERE quote_line_id = p_qte_line_id
1206: AND quote_header_id = p_qte_header_id;
1207:
1208:

Line 1210: SELECT demand_class_code FROM ASO_shipments

1206: AND quote_header_id = p_qte_header_id;
1207:
1208:
1209: CURSOR c_header_shipment IS
1210: SELECT demand_class_code FROM ASO_shipments
1211: WHERE quote_header_id = p_qte_header_id
1212: AND quote_line_id IS NULL;
1213:
1214: l_demand_class_code varchar2(30) := null;

Line 1274: SELECT ship_to_party_site_id FROM ASO_shipments

1270:
1271: IS
1272:
1273: CURSOR c_line_shipment IS
1274: SELECT ship_to_party_site_id FROM ASO_shipments
1275: WHERE quote_line_id = p_qte_line_id
1276: AND quote_header_id = p_qte_header_id;
1277:
1278:

Line 1280: SELECT ship_to_party_site_id FROM ASO_shipments

1276: AND quote_header_id = p_qte_header_id;
1277:
1278:
1279: CURSOR c_header_shipment IS
1280: SELECT ship_to_party_site_id FROM ASO_shipments
1281: WHERE quote_header_id = p_qte_header_id
1282: AND quote_line_id IS NULL;
1283:
1284: l_ship_to_party_site_id number := null;

Line 1344: SELECT ship_to_cust_account_id FROM ASO_shipments

1340:
1341: IS
1342:
1343: CURSOR c_line_shipment IS
1344: SELECT ship_to_cust_account_id FROM ASO_shipments
1345: WHERE quote_line_id = p_qte_line_id
1346: AND quote_header_id = p_qte_header_id;
1347:
1348:

Line 1350: SELECT ship_to_cust_account_id FROM ASO_shipments

1346: AND quote_header_id = p_qte_header_id;
1347:
1348:
1349: CURSOR c_header_shipment IS
1350: SELECT ship_to_cust_account_id FROM ASO_shipments
1351: WHERE quote_header_id = p_qte_header_id
1352: AND quote_line_id IS NULL;
1353:
1354: l_ship_to_cust_account_id number := null;