APPS.INVPPROC dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 1428: FROM MTL_ITEM_REVISIONS_INTERFACE R

1424: r.CURRENT_PHASE_ID,
1425: r.REVISION_ID,
1426: r.REVISION_LABEL,
1427: r.REVISION_REASON
1428: FROM MTL_ITEM_REVISIONS_INTERFACE R
1429: WHERE r.process_flag = l_process_flag_4
1430: AND r.set_process_id = xset_id
1431: AND r.transaction_type = l_transaction_type;
1432:

Line 1460: FROM MTL_ITEM_REVISIONS_INTERFACE r,

1456: user_id,
1457: login_id,
1458: L.LANGUAGE_CODE,
1459: USERENV('LANG')
1460: FROM MTL_ITEM_REVISIONS_INTERFACE r,
1461: FND_LANGUAGES L
1462: WHERE r.process_flag = l_process_flag_4
1463: AND r.set_process_id = xset_id
1464: AND r.transaction_type = l_transaction_type

Line 1479: ** record in mtl_item_revisions_interface in the

1475:
1476: /*NP 22AUG94 Commenting out the code for the following functionality
1477: ** If a master record was inserted for an orphan child record,
1478: ** we need to create a default
1479: ** record in mtl_item_revisions_interface in the
1480: ** master org (which is stored in last_updated_by
1481: ** The TWO-PASS approach makes it irrelevant
1482: ** Note the use of the last_updated_by who column
1483: ** This is initialized in INVPUTLI and holds the master_org_id

Line 1975: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';

1971: LAST_UPDATE_LOGIN = nvl(LAST_UPDATE_LOGIN,login_id)
1972: where process_flag = l_process_flag_4
1973: and set_process_id = xset_id;
1974:
1975: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';
1976:
1977: update MTL_ITEM_REVISIONS_INTERFACE
1978: set process_flag = l_process_flag_7,
1979: request_id = nvl(request_id,req_id),

Line 1977: update MTL_ITEM_REVISIONS_INTERFACE

1973: and set_process_id = xset_id;
1974:
1975: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';
1976:
1977: update MTL_ITEM_REVISIONS_INTERFACE
1978: set process_flag = l_process_flag_7,
1979: request_id = nvl(request_id,req_id),
1980: program_application_id = nvl(program_application_id,prg_appid),
1981: PROGRAM_ID = nvl(PROGRAM_ID,prg_id),