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 135: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

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

Line 172: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

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

Line 286: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

282: , ol.link_to_line_id
283: FROM
284: WSH_NEW_DELIVERIES_OB_GRP_V wnd
285: , wsh_delivery_assignments_v wda
286: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
287: , OE_ORDER_LINES_ALL ol
288: , hr_organization_information hoi /*Bug 8467743*/
289: WHERE wnd.delivery_id = wda.delivery_id
290: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 446: , wsh_delivery_details_ob_grp_v wdd

442: , oola.order_quantity_uom
443: FROM
444: OE_ORDER_HEADERS_ALL ooha
445: , OE_ORDER_LINES_ALL oola
446: , wsh_delivery_details_ob_grp_v wdd
447: , wsh_new_deliveries_ob_grp_v wnd
448: , wsh_delivery_assignments_v wda
449: , HZ_PARTIES rac
450: , HZ_CUST_ACCOUNTS hzc

Line 959: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;

955: , x_return_status OUT NOCOPY VARCHAR2
956: )
957: IS
958: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
959: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;
960: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_SO_Transactions';
961: BEGIN
962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
963: THEN

Line 975: FROM wsh_delivery_details_ob_grp_v

971:
972: --Find out the current status
973: SELECT mvt_stat_status
974: INTO l_mvt_stat_status
975: FROM wsh_delivery_details_ob_grp_v
976: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
977:
978: -- Update the transaction table
979: IF l_mvt_stat_status = 'NEW'

Line 986: UPDATE wsh_delivery_details

982: THEN
983: --cross legal entity SO, the arrival is already created,so set the status
984: --to "FORDISP" to be picked up again when run processor in other legal
985: --entity
986: UPDATE wsh_delivery_details
987: SET mvt_stat_status = 'FORDISP'
988: , movement_id = p_movement_transaction.movement_id
989: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
990: ELSIF p_status = 'DISPPROCESSED'

Line 995: UPDATE wsh_delivery_details

991: THEN
992: --cross legal entity SO, the dispatch is already created,so set the status
993: --to "FORARVL" to be picked up again when run processor in other legal
994: --entity
995: UPDATE wsh_delivery_details
996: SET mvt_stat_status = 'FORARVL'
997: , movement_id = p_movement_transaction.movement_id
998: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
999: ELSE

Line 1001: UPDATE wsh_delivery_details

997: , movement_id = p_movement_transaction.movement_id
998: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
999: ELSE
1000: --Regular SO
1001: UPDATE wsh_delivery_details
1002: SET mvt_stat_status = 'PROCESSED'
1003: , movement_id = p_movement_transaction.movement_id
1004: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
1005: END IF;

Line 1007: UPDATE wsh_delivery_details

1003: , movement_id = p_movement_transaction.movement_id
1004: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
1005: END IF;
1006: ELSE
1007: UPDATE wsh_delivery_details
1008: SET mvt_stat_status = 'PROCESSED'
1009: , movement_id = p_movement_transaction.movement_id
1010: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
1011: END IF;

Line 1059: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;

1055: , x_return_status OUT NOCOPY VARCHAR2
1056: )
1057: IS
1058: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1059: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;
1060: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_KIT_SO_Transactions';
1061: BEGIN
1062: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1063: THEN

Line 1075: FROM wsh_delivery_details_ob_grp_v

1071:
1072: --Find out the current status
1073: SELECT mvt_stat_status
1074: INTO l_mvt_stat_status
1075: FROM wsh_delivery_details_ob_grp_v
1076: WHERE delivery_detail_id = p_delivery_detail_id;
1077:
1078: -- Update the transaction table
1079: IF l_mvt_stat_status = 'NEW'

Line 1086: UPDATE wsh_delivery_details

1082: THEN
1083: --cross legal entity SO, the arrival is already created,so set the status
1084: --to "FORDISP" to be picked up again when run processor in other legal
1085: --entity
1086: UPDATE wsh_delivery_details
1087: SET mvt_stat_status = 'FORDISP'
1088: , movement_id = p_movement_id
1089: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1090: FROM oe_order_lines_all

Line 1097: UPDATE wsh_delivery_details

1093: THEN
1094: --cross legal entity SO, the dispatch is already created,so set the status
1095: --to "FORARVL" to be picked up again when run processor in other legal
1096: --entity
1097: UPDATE wsh_delivery_details
1098: SET mvt_stat_status = 'FORARVL'
1099: , movement_id = p_movement_id
1100: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1101: FROM oe_order_lines_all

Line 1105: UPDATE wsh_delivery_details

1101: FROM oe_order_lines_all
1102: WHERE link_to_line_id = p_link_to_line_id);
1103: ELSE
1104: --Regular SO
1105: UPDATE wsh_delivery_details
1106: SET mvt_stat_status = 'PROCESSED'
1107: , movement_id = p_movement_id
1108: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1109: FROM oe_order_lines_all

Line 1113: UPDATE wsh_delivery_details

1109: FROM oe_order_lines_all
1110: WHERE link_to_line_id = p_link_to_line_id);
1111: END IF;
1112: ELSE
1113: UPDATE wsh_delivery_details
1114: SET mvt_stat_status = 'PROCESSED'
1115: , movement_id = p_movement_id
1116: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1117: FROM oe_order_lines_all

Line 1173: wsh_delivery_details

1169: IS
1170: SELECT
1171: mvt_stat_status
1172: FROM
1173: wsh_delivery_details
1174: WHERE
1175: delivery_detail_id = p_delivery_detail_id;
1176: BEGIN
1177: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 1261: wsh_delivery_details

1257: IS
1258: SELECT
1259: mvt_stat_status
1260: FROM
1261: wsh_delivery_details
1262: WHERE
1263: delivery_detail_id = p_delivery_detail_id;
1264: BEGIN
1265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)