DBA Data[Home] [Help]

APPS.PA_TXN_ACCUMS dependencies on PA_COMMITMENT_TXNS_S

Line 22: pa_commitment_txns_s.NEXTVAL

18: FUNCTION cmt_line_id RETURN NUMBER IS
19: cmt_line_id NUMBER;
20: BEGIN
21: SELECT
22: pa_commitment_txns_s.NEXTVAL
23: INTO cmt_line_id
24: FROM
25: SYS.DUAL;
26: RETURN cmt_line_id;

Line 2084: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,

2080: RESOURCE_CLASS,
2081: CBS_ELEMENT_ID --16461684
2082: )
2083: select /*+ push_pred(pctv) */
2084: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,
2085: pctv.PROJECT_ID,
2086: pctv.TASK_ID,
2087: pctv.TRANSACTION_SOURCE,
2088: decode(pctv.LINE_TYPE,

Line 2357: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,

2353: BOM_EQUIPMENT_RESOURCE_ID,
2354: RESOURCE_CLASS
2355: )
2356: select
2357: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,
2358: pctv.PROJECT_ID,
2359: pctv.TASK_ID,
2360: pctv.TRANSACTION_SOURCE,
2361: pctv.LINE_TYPE,