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.INV_MGD_MVT_SO_MDTR dependencies on WSH_DELIVERY_DETAILS

Line 98: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

94: , ol.link_to_line_id
95: FROM
96: WSH_NEW_DELIVERIES_OB_GRP_V wnd
97: , wsh_delivery_assignments_v wda
98: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
99: , hr_organization_information hoi
100: , OE_ORDER_LINES_ALL ol
101: , OE_ORDER_HEADERS_ALL oh
102: , HZ_CUST_SITE_USES_ALL ras

Line 134: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

130: , ol.link_to_line_id
131: FROM
132: WSH_NEW_DELIVERIES_OB_GRP_V wnd
133: , wsh_delivery_assignments_v wda
134: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
135: , hr_organization_information hoi
136: , OE_ORDER_LINES_ALL ol
137: , OE_ORDER_HEADERS_ALL oh
138: , HZ_CUST_SITE_USES_ALL ras

Line 170: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

166: , ol.link_to_line_id
167: FROM
168: WSH_NEW_DELIVERIES_OB_GRP_V wnd
169: , wsh_delivery_assignments_v wda
170: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
171: , OE_ORDER_LINES_ALL ol
172: , OE_ORDER_HEADERS_ALL oh
173: , HZ_CUST_SITE_USES_ALL ras
174: , hr_organization_information hoi

Line 283: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

279: , ol.link_to_line_id
280: FROM
281: WSH_NEW_DELIVERIES_OB_GRP_V wnd
282: , wsh_delivery_assignments_v wda
283: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
284: , OE_ORDER_LINES_ALL ol
285: WHERE wnd.delivery_id = wda.delivery_id
286: AND wda.delivery_detail_id = wdd.delivery_detail_id
287: AND wdd.source_line_id = ol.line_id

Line 436: , wsh_delivery_details_ob_grp_v wdd

432: , oola.order_quantity_uom
433: FROM
434: OE_ORDER_HEADERS_ALL ooha
435: , OE_ORDER_LINES_ALL oola
436: , wsh_delivery_details_ob_grp_v wdd
437: , wsh_new_deliveries_ob_grp_v wnd
438: , wsh_delivery_assignments_v wda
439: , HZ_PARTIES rac
440: , HZ_CUST_ACCOUNTS hzc

Line 920: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;

916: , x_return_status OUT NOCOPY VARCHAR2
917: )
918: IS
919: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
920: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;
921: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_SO_Transactions';
922: BEGIN
923: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
924: THEN

Line 936: FROM wsh_delivery_details_ob_grp_v

932:
933: --Find out the current status
934: SELECT mvt_stat_status
935: INTO l_mvt_stat_status
936: FROM wsh_delivery_details_ob_grp_v
937: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
938:
939: -- Update the transaction table
940: IF l_mvt_stat_status = 'NEW'

Line 947: UPDATE wsh_delivery_details

943: THEN
944: --cross legal entity SO, the arrival is already created,so set the status
945: --to "FORDISP" to be picked up again when run processor in other legal
946: --entity
947: UPDATE wsh_delivery_details
948: SET mvt_stat_status = 'FORDISP'
949: , movement_id = p_movement_transaction.movement_id
950: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
951: ELSIF p_status = 'DISPPROCESSED'

Line 956: UPDATE wsh_delivery_details

952: THEN
953: --cross legal entity SO, the dispatch is already created,so set the status
954: --to "FORARVL" to be picked up again when run processor in other legal
955: --entity
956: UPDATE wsh_delivery_details
957: SET mvt_stat_status = 'FORARVL'
958: , movement_id = p_movement_transaction.movement_id
959: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
960: ELSE

Line 962: UPDATE wsh_delivery_details

958: , movement_id = p_movement_transaction.movement_id
959: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
960: ELSE
961: --Regular SO
962: UPDATE wsh_delivery_details
963: SET mvt_stat_status = 'PROCESSED'
964: , movement_id = p_movement_transaction.movement_id
965: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
966: END IF;

Line 968: UPDATE wsh_delivery_details

964: , movement_id = p_movement_transaction.movement_id
965: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
966: END IF;
967: ELSE
968: UPDATE wsh_delivery_details
969: SET mvt_stat_status = 'PROCESSED'
970: , movement_id = p_movement_transaction.movement_id
971: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
972: END IF;

Line 1020: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;

1016: , x_return_status OUT NOCOPY VARCHAR2
1017: )
1018: IS
1019: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1020: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;
1021: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_KIT_SO_Transactions';
1022: BEGIN
1023: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1024: THEN

Line 1036: FROM wsh_delivery_details_ob_grp_v

1032:
1033: --Find out the current status
1034: SELECT mvt_stat_status
1035: INTO l_mvt_stat_status
1036: FROM wsh_delivery_details_ob_grp_v
1037: WHERE delivery_detail_id = p_delivery_detail_id;
1038:
1039: -- Update the transaction table
1040: IF l_mvt_stat_status = 'NEW'

Line 1047: UPDATE wsh_delivery_details

1043: THEN
1044: --cross legal entity SO, the arrival is already created,so set the status
1045: --to "FORDISP" to be picked up again when run processor in other legal
1046: --entity
1047: UPDATE wsh_delivery_details
1048: SET mvt_stat_status = 'FORDISP'
1049: , movement_id = p_movement_id
1050: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1051: FROM oe_order_lines_all

Line 1058: UPDATE wsh_delivery_details

1054: THEN
1055: --cross legal entity SO, the dispatch is already created,so set the status
1056: --to "FORARVL" to be picked up again when run processor in other legal
1057: --entity
1058: UPDATE wsh_delivery_details
1059: SET mvt_stat_status = 'FORARVL'
1060: , movement_id = p_movement_id
1061: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1062: FROM oe_order_lines_all

Line 1066: UPDATE wsh_delivery_details

1062: FROM oe_order_lines_all
1063: WHERE link_to_line_id = p_link_to_line_id);
1064: ELSE
1065: --Regular SO
1066: UPDATE wsh_delivery_details
1067: SET mvt_stat_status = 'PROCESSED'
1068: , movement_id = p_movement_id
1069: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1070: FROM oe_order_lines_all

Line 1074: UPDATE wsh_delivery_details

1070: FROM oe_order_lines_all
1071: WHERE link_to_line_id = p_link_to_line_id);
1072: END IF;
1073: ELSE
1074: UPDATE wsh_delivery_details
1075: SET mvt_stat_status = 'PROCESSED'
1076: , movement_id = p_movement_id
1077: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1078: FROM oe_order_lines_all

Line 1134: wsh_delivery_details

1130: IS
1131: SELECT
1132: mvt_stat_status
1133: FROM
1134: wsh_delivery_details
1135: WHERE
1136: delivery_detail_id = p_delivery_detail_id;
1137: BEGIN
1138: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 1222: wsh_delivery_details

1218: IS
1219: SELECT
1220: mvt_stat_status
1221: FROM
1222: wsh_delivery_details
1223: WHERE
1224: delivery_detail_id = p_delivery_detail_id;
1225: BEGIN
1226: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)