APPS.WIP_AUTOLOTPROC_PRIV dependencies on MTL_SERIAL_NUMBERS

Line 1898: from mtl_serial_numbers

1894:
1895: if(p_txnActionID in (wip_constants.isscomp_action, wip_constants.retnegc_action)) then
1896: select nvl(max(count(*)), 0)
1897: into l_serCount
1898: from mtl_serial_numbers
1899: where current_organization_id = p_orgID
1900: and inventory_item_id = p_itemID
1901: and current_status = 3
1902: and (group_mark_id = -1 OR group_mark_id is null)

Line 1920: from mtl_serial_numbers

1916:
1917: elsif(p_txnActionID = wip_constants.retcomp_action) then
1918: select nvl(max(count(*)), 0)
1919: into l_serCount
1920: from mtl_serial_numbers
1921: where current_organization_id = p_orgID
1922: and inventory_item_id = p_itemID
1923: and current_status = 4
1924: and (group_mark_id = -1 OR group_mark_id is null)

Line 1951: from mtl_serial_numbers

1947: return;
1948: else
1949: select count(*)
1950: into l_serCount
1951: from mtl_serial_numbers
1952: where current_organization_id = p_orgID
1953: and inventory_item_id = p_itemID
1954: and current_status in (1, 6)
1955: and (group_mark_id = -1 OR group_mark_id is null)

Line 2039: from mtl_serial_numbers_temp

2035: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2036: cursor c_tmpSerials is
2037: select fm_serial_number fmSerial,
2038: to_serial_number toSerial
2039: from mtl_serial_numbers_temp
2040: where transaction_temp_id = p_txnTmpID;
2041:
2042: cursor c_intSerials is
2043: select fm_serial_number fmSerial,

Line 2045: from mtl_serial_numbers_interface

2041:
2042: cursor c_intSerials is
2043: select fm_serial_number fmSerial,
2044: to_serial_number toSerial
2045: from mtl_serial_numbers_interface
2046: where transaction_interface_id = p_txnIntID;
2047: begin
2048: x_returnStatus := fnd_api.g_ret_sts_success;
2049: if (l_logLevel <= wip_constants.trace_logging) then