APPS.INV_CYC_LOVS dependencies on STANDARD

Line 1231: standard_operation_id,

1227: neg_adjustment_quantity,
1228: neg_adjustment_amount,
1229: export_flag,
1230: task_priority,
1231: standard_operation_id,
1232: parent_lpn_id,
1233: outermost_lpn_id,
1234: cost_group_id
1235: -- INVCONV, NSRIVAST

Line 1333: g_cc_entry.standard_operation_id,

1329: g_cc_entry.neg_adjustment_quantity,
1330: g_cc_entry.neg_adjustment_amount,
1331: g_cc_entry.export_flag,
1332: g_cc_entry.task_priority,
1333: g_cc_entry.standard_operation_id,
1334: g_cc_entry.parent_lpn_id,
1335: g_cc_entry.outermost_lpn_id,
1336: g_cc_entry.cost_group_id
1337: -- INVCONV, NSRIVAST

Line 5007: -- For standard costed orgs, get the item cost with the common

5003: l_locator_id := NULL;
5004: END IF;
5005:
5006: -- Bug# 2094288
5007: -- For standard costed orgs, get the item cost with the common
5008: -- cost group ID = 1 always. For average costed orgs, use the
5009: -- cost group ID stamped on the transaction
5010: -- Bug # 2180251: All primary costing methods not equal to 1 should
5011: -- also be considered as an average costed org

Line 9943: l_standard_operation_id NUMBER;

9939: l_wdt_rowcnt NUMBER :=0;
9940: l_person_resource_id NUMBER;
9941: l_machine_resource_id NUMBER;
9942: l_equipment_id NUMBER;
9943: l_standard_operation_id NUMBER;
9944: l_transaction_temp_id NUMBER;
9945: l_task_priority NUMBER;
9946: BEGIN
9947:

Line 9971: AND standard_operation_id is not null;

9967: AND inventory_item_id = p_item_id
9968: AND nvl(revision,'###') = nvl(p_revision,'###')
9969: AND nvl(subinventory,'@@@')= nvl(p_sub_code,'@@@')
9970: AND nvl(locator_id,-999) = nvl(p_loc_id,-999)
9971: AND standard_operation_id is not null;
9972:
9973: IF p_cycle_count_entry_id is not null THEN
9974: l_transaction_temp_id := p_cycle_count_entry_id;
9975: END IF;

Line 9977: SELECT nvl(standard_operation_id,0),nvl(task_priority,0)

9973: IF p_cycle_count_entry_id is not null THEN
9974: l_transaction_temp_id := p_cycle_count_entry_id;
9975: END IF;
9976:
9977: SELECT nvl(standard_operation_id,0),nvl(task_priority,0)
9978: INTO l_standard_operation_id,l_task_priority
9979: from mtl_cycle_count_entries
9980: WHERE cycle_count_entry_id = l_transaction_temp_id;
9981:

Line 9978: INTO l_standard_operation_id,l_task_priority

9974: l_transaction_temp_id := p_cycle_count_entry_id;
9975: END IF;
9976:
9977: SELECT nvl(standard_operation_id,0),nvl(task_priority,0)
9978: INTO l_standard_operation_id,l_task_priority
9979: from mtl_cycle_count_entries
9980: WHERE cycle_count_entry_id = l_transaction_temp_id;
9981:
9982: BEGIN

Line 10006: AND standard_operation_id = l_standard_operation_id

10002: l_machine_resource_id,
10003: l_equipment_id
10004: FROM wms_person_resource_utt_v
10005: WHERE emp_id = p_employee_id
10006: AND standard_operation_id = l_standard_operation_id
10007: AND NVL(eqp_id, -999) = NVL(p_sign_on_equipment_id, NVL(eqp_id, -999));
10008:
10009: IF l_wdt_rowcnt = 0 THEN
10010:

Line 10038: l_standard_operation_id,

10034: VALUES
10035: (wms_dispatched_tasks_s.NEXTVAL,
10036: l_transaction_temp_id,
10037: p_organization_id,
10038: l_standard_operation_id,
10039: p_employee_id,
10040: sysdate,
10041: sysdate,
10042: l_equipment_id,