DBA Data[Home] [Help]

APPS.INL_LANDEDCOST_PVT dependencies on INL_SHIP_HEADERS_ALL

Line 984: FROM inl_ship_headers_all

980: -- Get Inventory Organization. It will be used when getting Item info.
981: --
982: SELECT organization_id
983: INTO l_inv_org_id
984: FROM inl_ship_headers_all
985: WHERE ship_header_id = p_ship_header_id;
986:
987: INL_LOGGING_PVT.Log_Variable (
988: p_module_name => g_module_name,

Line 1401: FROM inl_ship_headers_all

1397: -- Get Inventory Organization. It will be used when getting Item info.
1398: --
1399: SELECT organization_id
1400: INTO l_inv_org_id
1401: FROM inl_ship_headers_all
1402: WHERE ship_header_id = p_ship_header_id;
1403:
1404:
1405: INL_LOGGING_PVT.Log_Variable (

Line 3356: inl_ship_headers_all oh

3352: l_last_adjustment_num,
3353: l_ship_status_code
3354: FROM gl_ledgers gl,
3355: xle_fp_ou_ledger_v l,
3356: inl_ship_headers_all oh
3357: WHERE gl.ledger_id = l.ledger_id
3358: AND l.legal_entity_id = oh.legal_entity_id
3359: AND oh.ship_header_id = p_ship_header_id;
3360:

Line 3408: UPDATE inl_ship_headers_all

3404: --- SCM-051
3405: IF ABS(l_first_adjustment_num) = ABS(l_last_adjustment_num) THEN
3406: l_last_adjustment_num := ABS(l_last_adjustment_num) + 1;
3407: --- SCM-051
3408: UPDATE inl_ship_headers_all
3409: SET
3410: adjustment_num = l_last_adjustment_num
3411: WHERE ship_header_id = p_ship_header_id;
3412: END IF;

Line 3509: inl_ship_headers_all sh

3505: )) adj_num
3506: INTO l_current_adjustment_num
3507: FROM
3508: inl_associations a,
3509: inl_ship_headers_all sh
3510: WHERE a.ship_header_id(+) = sh.ship_header_id
3511: AND sh.ship_header_id = p_ship_header_id
3512: ;
3513: --Bug#14081759 END