APPS.GMI_SHIPPING_UTIL dependencies on IC_TXN_REQUEST_LINES

Line 1878: Update IC_TXN_REQUEST_LINES

1874: EXIT WHEN get_move_order%NOTFOUND;
1875:
1876: GMI_RESERVATION_UTIL.println('Mo_ID=' || l_move_order.move_order_line_id ||', txn_source_line_id='||p_source_line_id ||', Status='|| l_move_order.released_status);
1877:
1878: Update IC_TXN_REQUEST_LINES
1879: SET TXN_SOURCE_LINE_ID = p_source_line_id
1880: WHERE line_id = l_move_order.move_order_line_id;
1881:
1882: IF (SQL%NOTFOUND) THEN

Line 3068: FROM ic_txn_request_lines mo

3064: , wdd.inventory_item_id ITEM_ID
3065: , wdd.organization_id SHIP_ORG
3066: , wdd.delivery_detail_id SHIP_ID
3067: , wdd.SHIPPED_QUANTITY SHIP_QTY
3068: FROM ic_txn_request_lines mo
3069: , wsh_delivery_details wdd
3070: , oe_order_headers_all soh
3071: , oe_order_lines_all sol
3072: , mtl_parameters mp1

Line 3104: FROM ic_txn_request_lines mo

3100: --Removed the reference to "apps".
3101: Cursor count_unstaged_wdd_for_mo (p_line_id IN NUMBER)
3102: IS
3103: Select count(*)
3104: FROM ic_txn_request_lines mo
3105: , wsh_delivery_details wdd
3106: Where mo.txn_source_line_id = p_line_id
3107: and mo.line_status in (3,7)
3108: and mo.line_id = wdd.move_order_line_id

Line 3339: FROM ic_txn_request_lines mo

3335: --Removed the reference to "apps".
3336:
3337: Select wdd.delivery_detail_id
3338: Into l_line_detail_id
3339: FROM ic_txn_request_lines mo
3340: , wsh_delivery_details wdd
3341: Where mo.txn_source_line_id = lines.line_id
3342: and mo.line_status in (3,7)
3343: and mo.line_id = wdd.move_order_line_id