APPS.WIP_AUTOLOTPROC_PRIV dependencies on MTL_SERIAL_NUMBERS

Line 1969: from mtl_serial_numbers

1965:
1966: if(p_txnActionID in (wip_constants.isscomp_action, wip_constants.retnegc_action)) then
1967: select nvl(max(count(*)), 0)
1968: into l_serCount
1969: from mtl_serial_numbers
1970: where current_organization_id = p_orgID
1971: and inventory_item_id = p_itemID
1972: and current_status = 3
1973: and (group_mark_id = -1 OR group_mark_id is null)

Line 1991: from mtl_serial_numbers

1987:
1988: elsif(p_txnActionID = wip_constants.retcomp_action) then
1989: select nvl(max(count(*)), 0)
1990: into l_serCount
1991: from mtl_serial_numbers
1992: where current_organization_id = p_orgID
1993: and inventory_item_id = p_itemID
1994: and current_status = 4
1995: and (group_mark_id = -1 OR group_mark_id is null)

Line 2022: from mtl_serial_numbers

2018: return;
2019: else
2020: select count(*)
2021: into l_serCount
2022: from mtl_serial_numbers
2023: where current_organization_id = p_orgID
2024: and inventory_item_id = p_itemID
2025: and current_status in (1, 6)
2026: and (group_mark_id = -1 OR group_mark_id is null)

Line 2110: from mtl_serial_numbers_temp

2106: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2107: cursor c_tmpSerials is
2108: select fm_serial_number fmSerial,
2109: to_serial_number toSerial
2110: from mtl_serial_numbers_temp
2111: where transaction_temp_id = p_txnTmpID;
2112:
2113: cursor c_intSerials is
2114: select fm_serial_number fmSerial,

Line 2116: from mtl_serial_numbers_interface

2112:
2113: cursor c_intSerials is
2114: select fm_serial_number fmSerial,
2115: to_serial_number toSerial
2116: from mtl_serial_numbers_interface
2117: where transaction_interface_id = p_txnIntID;
2118: begin
2119: x_returnStatus := fnd_api.g_ret_sts_success;
2120: if (l_logLevel <= wip_constants.trace_logging) then