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.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: /* Commented for Bug 12938390(11i Bug 10253993)

Line 481: FROM ASO_SHIPMENTS

477: /* Commented for Bug 12938390(11i Bug 10253993)
478: -- performance fix for bug 5596369
479: CURSOR c_ship_site2 IS
480: SELECT ship_to_party_site_id , SHIP_TO_CUST_ACCOUNT_ID
481: FROM ASO_SHIPMENTS
482: WHERE quote_header_id = p_qte_header_id
483: and shipment_id =p_shipment_id
484: AND quote_line_id IS NULL;
485: */

Line 490: FROM ASO_SHIPMENTS

486:
487: /* Cursor c_ship_site2 modified for Bug 12938390 (11i Bug 10253993) */
488: CURSOR c_ship_site2(p_ship_id Number) IS
489: SELECT ship_to_party_site_id , SHIP_TO_CUST_ACCOUNT_ID
490: FROM ASO_SHIPMENTS
491: WHERE quote_header_id = p_qte_header_id
492: AND shipment_id = p_ship_id
493: AND quote_line_id IS NULL;
494:

Line 503: SELECT SHIP_TO_CUST_ACCOUNT_ID FROM ASO_SHIPMENTS

499: SELECT cust_account_id FROM ASO_QUOTE_HEADERS_ALL
500: WHERE quote_header_id = p_qte_header_id;
501:
502: CURSOR c_ship_cust_id IS
503: SELECT SHIP_TO_CUST_ACCOUNT_ID FROM ASO_SHIPMENTS
504: WHERE quote_header_id = p_qte_header_id and quote_line_id =p_qte_line_id and shipment_id =p_shipment_id;
505:
506: /* Commented for Bug 12938390(11i Bug 12426838)
507: -- bug 5596369

Line 510: FROM ASO_SHIPMENTS

506: /* Commented for Bug 12938390(11i Bug 12426838)
507: -- bug 5596369
508: CURSOR c_ship_cust_id1 IS
509: SELECT SHIP_TO_CUST_ACCOUNT_ID
510: FROM ASO_SHIPMENTS
511: WHERE quote_header_id = p_qte_header_id
512: and shipment_id =p_shipment_id
513: and quote_line_id IS NULL;
514: */

Line 519: FROM ASO_SHIPMENTS

515:
516: /* Cursor c_ship_cust_id1 modified for Bug 12938390(11i Bug 12426838) */
517: CURSOR c_ship_cust_id1(p_ship_id Number) IS
518: SELECT SHIP_TO_CUST_ACCOUNT_ID
519: FROM ASO_SHIPMENTS
520: WHERE quote_header_id = p_qte_header_id
521: and shipment_id = p_ship_id
522: and quote_line_id IS NULL;
523:

Line 548: from aso_shipments

544: where quote_line_id = p_qte_line_id;
545:
546: cursor c_shipment_id (p_line_id NUMBER) is
547: select shipment_id
548: from aso_shipments
549: where quote_line_id = p_line_id
550: and quote_header_id = p_qte_header_id;
551:
552: l_cust_id NUMBER;

Line 565: FROM ASO_SHIPMENTS

561:
562: /* Start : Code change for Bug 12938390(11i Bug 10253993) */
563: CURSOR C_SHIPMENT IS
564: SELECT SHIPMENT_ID
565: FROM ASO_SHIPMENTS
566: WHERE quote_header_id = p_qte_header_id
567: AND quote_line_id IS NULL;
568:
569: l_shipment_id NUMBER;

Line 840: SELECT ship_to_party_site_id FROM ASO_SHIPMENTS

836: p_qte_line_id NUMBER,
837: p_shipment_id NUMBER) RETURN NUMBER
838: IS
839: CURSOR c_ship_site1 IS
840: SELECT ship_to_party_site_id FROM ASO_SHIPMENTS
841: WHERE shipment_id = p_shipment_id
842: AND quote_line_id = p_qte_line_id
843: AND quote_header_id = p_qte_header_id;
844:

Line 846: SELECT ship_to_party_site_id FROM ASO_SHIPMENTS

842: AND quote_line_id = p_qte_line_id
843: AND quote_header_id = p_qte_header_id;
844:
845: CURSOR c_ship_site2 IS
846: SELECT ship_to_party_site_id FROM ASO_SHIPMENTS
847: WHERE quote_line_id IS NULL AND quote_header_id = p_qte_header_id;
848:
849: l_ship_site_id NUMBER;
850:

Line 867: from aso_shipments

863: where quote_line_id = p_qte_line_id;
864:
865: cursor c_shipment_id (p_line_id NUMBER) is
866: select shipment_id
867: from aso_shipments
868: where quote_line_id = p_line_id
869: and quote_header_id = p_qte_header_id;
870:
871: l_model_quote_line_id NUMBER;

Line 1137: SELECT ship_from_org_id FROM ASO_shipments

1133:
1134: IS
1135:
1136: CURSOR c_line_shipment IS
1137: SELECT ship_from_org_id FROM ASO_shipments
1138: WHERE quote_line_id = p_qte_line_id
1139: AND quote_header_id = p_qte_header_id;
1140:
1141:

Line 1143: SELECT ship_from_org_id FROM ASO_shipments

1139: AND quote_header_id = p_qte_header_id;
1140:
1141:
1142: CURSOR c_header_shipment IS
1143: SELECT ship_from_org_id FROM ASO_shipments
1144: WHERE quote_header_id = p_qte_header_id
1145: AND quote_line_id IS NULL;
1146:
1147: l_ship_from_org_id NUMBER;

Line 1188: SELECT ship_method_code FROM ASO_shipments

1184:
1185: IS
1186:
1187: CURSOR c_line_shipment IS
1188: SELECT ship_method_code FROM ASO_shipments
1189: WHERE quote_line_id = p_qte_line_id
1190: AND quote_header_id = p_qte_header_id;
1191:
1192:

Line 1194: SELECT ship_method_code FROM ASO_shipments

1190: AND quote_header_id = p_qte_header_id;
1191:
1192:
1193: CURSOR c_header_shipment IS
1194: SELECT ship_method_code FROM ASO_shipments
1195: WHERE quote_header_id = p_qte_header_id
1196: AND quote_line_id IS NULL;
1197:
1198: l_ship_method_code varchar2(30) := null;

Line 1258: SELECT demand_class_code FROM ASO_shipments

1254:
1255: IS
1256:
1257: CURSOR c_line_shipment IS
1258: SELECT demand_class_code FROM ASO_shipments
1259: WHERE quote_line_id = p_qte_line_id
1260: AND quote_header_id = p_qte_header_id;
1261:
1262:

Line 1264: SELECT demand_class_code FROM ASO_shipments

1260: AND quote_header_id = p_qte_header_id;
1261:
1262:
1263: CURSOR c_header_shipment IS
1264: SELECT demand_class_code FROM ASO_shipments
1265: WHERE quote_header_id = p_qte_header_id
1266: AND quote_line_id IS NULL;
1267:
1268: l_demand_class_code varchar2(30) := null;

Line 1328: SELECT ship_to_party_site_id FROM ASO_shipments

1324:
1325: IS
1326:
1327: CURSOR c_line_shipment IS
1328: SELECT ship_to_party_site_id FROM ASO_shipments
1329: WHERE quote_line_id = p_qte_line_id
1330: AND quote_header_id = p_qte_header_id;
1331:
1332:

Line 1334: SELECT ship_to_party_site_id FROM ASO_shipments

1330: AND quote_header_id = p_qte_header_id;
1331:
1332:
1333: CURSOR c_header_shipment IS
1334: SELECT ship_to_party_site_id FROM ASO_shipments
1335: WHERE quote_header_id = p_qte_header_id
1336: AND quote_line_id IS NULL;
1337:
1338: l_ship_to_party_site_id number := null;

Line 1398: SELECT ship_to_cust_account_id FROM ASO_shipments

1394:
1395: IS
1396:
1397: CURSOR c_line_shipment IS
1398: SELECT ship_to_cust_account_id FROM ASO_shipments
1399: WHERE quote_line_id = p_qte_line_id
1400: AND quote_header_id = p_qte_header_id;
1401:
1402:

Line 1404: SELECT ship_to_cust_account_id FROM ASO_shipments

1400: AND quote_header_id = p_qte_header_id;
1401:
1402:
1403: CURSOR c_header_shipment IS
1404: SELECT ship_to_cust_account_id FROM ASO_shipments
1405: WHERE quote_header_id = p_qte_header_id
1406: AND quote_line_id IS NULL;
1407:
1408: l_ship_to_cust_account_id number := null;